← Return to doc.sitecore.com

Valid for Sitecore 5.3.2, 5.3.1, 5.1.1 and 5.2

5. Migrating to SQL Server

This chapter describes how to create tables, import data and configure the module when migrating to SQL Server.

5.1. Creating the Tables on SQL Server

Create a new blank database on Sql Server called MailingList.
Run the script in /sitecore modules/shell/mailinglist/core/mailinglist.sql on this database.

5.2. Importing Data to SQL Server

In Enterprise Manager select DB Mailinglist and choose for it All Tasks » Import
Select Access as datasource
Browse to existing .mdb file
Select all tables (but not views) except ListLog, MailStatistics and SubscriberFields and finish import.
Repeat above procedure, this time selecting only ListLog, MailStatistics and SubscriberFields.

5.3. Configuration

On Settings page change Database setting to "MSSQLSERVER"
On Settings page change ConnectionString setting to connection string for the new Sql Server database: e.g.
"user id=sa;password=;initial catalog=mailinglist;data source=mysqlserver;Connect Timeout=30"
Before first email sending please do full publishing

Test the configuration.